Re: odbc with unicode support

From	Jos Geerts <jgeert1@its.jnj.com>
Subject	Re: odbc with unicode support
Newsgroups	comp.lang.php
References	<p6PID.256320$1C7.180194@usenetxs.com> <g5huiuFb3ugU1@mid.individual.net>
Message-ID	<dMPID.227315$e55.159952@usenetxs.com> (permalink)
Date	2018-11-20 08:40 +0000

Show all headers | View raw

On Tue, 20 Nov 2018 09:22:52 +0100, Arno Welzel wrote:

> Jos Geerts:
> 
>> Hi all,
>> 
>> Is it a big effort to change the existing odbc driver to support
>> unicode (I need this to access databases with unicode data - chinese,
>> japanse, cyrillic - character sets?
>> 
>> Currently the driver/extention automatically change the data to ansi
>> characterset, and that makes the data unusable as the data cannot be
>> converted from multibytes to just a single byte.
>> 
>> I did try to cast the data as "binary" and that worked, I retrieved the
>> data as-is, no conversion was done, so the unicode data was complete.
>> The problem is that not all sql languages support binary (Impala SQL
>> does not support it), so it's not always possible to cast the data as
>> binary.
>> 
>> So I'm a bit stuck here... :-(
> 
> Maybe this helps:
> 
> <https://www.easysoft.com/support/kb/kb01072.html>


I already have seen/read that article, and yes it provides some 
workarounds. But it's not solving my problem.

Back to comp.lang.php | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

odbc with unicode support "Jos Geerts" <jgeert1@its.jnj.com> - 2018-11-20 08:56 +0100
  Re: odbc with unicode support Arno Welzel <usenet@arnowelzel.de> - 2018-11-20 09:22 +0100
    Re: odbc with unicode support Jos Geerts <jgeert1@its.jnj.com> - 2018-11-20 08:40 +0000

csiph-web