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
[email protected]
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
--
_______________________________________________
Lazarus mailing list
[email protected]
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
