[erlang-questions] SQLite ODBC

Ingela Andin <>
Mon Apr 26 21:57:57 CEST 2010


2010/4/26 Robert Raschke <>:
> On Mon, Apr 26, 2010 at 12:44 PM, maruthavanan s <
>> wrote:
>
>>
>> Hi,
>>
>> I want to connect SQLite to ODBC drivers. Is this possible with latest
>> version?
>>
>> I was able to successfully connection but when I try to get the columns I
>> fail with "no column supported" error.
>>
>> Thanks,
>> Marutha
>>
>
>
> The  Erlang ODBC lib does not currently support Unicode. You will need to
> convert Unicode columns as part of your query. For example, by using ODBC
> conversion functions:
> SELECT {fn CONVERT(unicode_column, SQL_VARCHAR)} "char_column" FROM table

There will be some unicode support in the upcoming release, now
available in github if you are interested.

Regards Ingela, Erlang OTP team, Ericsson AB


More information about the erlang-questions mailing list