Re: multi byte character issue

What driver do you use to connect to the database?

There is a huge difference in behavior between MS ODBC and FreeTDS. See if this post is of any help.

Enjoy, Have FUN! H.Merijn

Comment on Re: multi byte character issue

Replies are listed 'Best First'.
Re^2: multi byte character issue by afoken (Chancellor) on Jan 03, 2020 at 13:11 UTC
Also note that DBD::ODBC can and does support Unicode (including UTF-8), but ONLY if it was compiled to do so. By default, Unicode support is enabled on Windows, but disabled on all other platforms. So if you need a DBD::ODBC with Unicode support on Linux or any other non-Windows platform, you have to tell DBD::ODBC's Makefile.pl by invoking it with the parameter `-u` (and recompile). See also "Enabling and Disabling Unicode support" in DBD::ODBC. Alexander -- Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)	[reply] [d/l]

Replies are listed 'Best First'.

Re^2: multi byte character issue
by afoken (Chancellor) on Jan 03, 2020 at 13:11 UTC

Also note that DBD::ODBC can and does support Unicode (including UTF-8), but ONLY if it was compiled to do so. By default, Unicode support is enabled on Windows, but disabled on all other platforms. So if you need a DBD::ODBC with Unicode support on Linux or any other non-Windows platform, you have to tell DBD::ODBC's Makefile.pl by invoking it with the parameter -u (and recompile). See also "Enabling and Disabling Unicode support" in DBD::ODBC.

Alexander

--
Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)

[reply]
[d/l]