[Lazarus] UTF16 2 utf8

[Eduard Filipas]

S, Joost van der Sluis piše:
> On Wed, 2011-05-04 at 12:19 +0200, Eduard Filipas wrote:
>> Hi all
>>
>> im bit lost with all this unicode support ..im tryin to make picture in
>> my head..here is my problem
>>
>> MS-SQLserver 2008 uses utf16 to represent data
> It does? Not by default. If you define your fields as varchar(x), it can
> be used to use UTF-8. nvarchar is utf-16 by default, off course.
>
I read that MS SQL server 2008 uses UCS2 which is UTF-16 ...im realy 
cofused by all this
>> lazarus uses UTF8
>> FPC doesnt use unicode
>>
>> my first question is ..is it possible at all to present valid data in
>> program compiled with lazarus that connects to MSSQL server?
> Just set your connection to UTF-8 and you're done. It doesn't matter how
> the data is stored. (But if you can choose, use nvarchar, so no
> conversion is needed)
>
> Joost.
i did look up my field in table and it is nvarchar and i have odbcConnection to msSQL server i added SQLquery and dataGrid but my local characters are not shown or are represented by question mark. i did set charactercode to UTF-8.


> --
> _______________________________________________
> Lazarus mailing list
> Lazarus at lists.lazarus.freepascal.org
> http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
>