Page 1 of 1

Encodeing problem

Posted: 16.05.2011, 21:19
by ahmed232323
Hello all
am new in Lazarus and Object Pascal generally
after a lot of time i succeed to connect to MSSQL through Zeos components in Lazarus
after i populated data to tables ,the Arabic strings shown as question marks.
How to solve this encoding Issue ?.
example عربي => ????
please Help! my decision :roll: to learn more about this language is depend on this

Posted: 17.05.2011, 07:54
by Wild_Pointer
Hello, ahmed232323,

May it be that you have forgoten to add codepage=utf8 in the properties of TZConnection? I assume your database is utf8 encoded....

Good luck!

P.S. I'm not working with MSSQL, PostgreSQL is a DBMS I like :)

Posted: 17.05.2011, 20:46
by ahmed232323
Hello, Wild_Pointer
thanks for your speedy reply.
Wild_Pointer wrote: May it be that you have forgoten to add codepage=utf8 in the properties of TZConnection?
I didn't find codePage property in TZConnection?.

Posted: 18.05.2011, 07:18
by Wild_Pointer
Hello ahmed232323,
I didn't find codePage property in TZConnection?.
well, there isn't. You should enter the line "codepage=utf8" to the TZConnection.Properties . I don't know if that will help for sure, but it's the way it works for postgresql...

Good luck.

Posted: 18.05.2011, 21:26
by ahmed232323
thanks ,Wild_Pointer

it didn't work also ,it's will be good if there is class and it's members documentations to find options to added to the TZConnection.Properties.
thanks, again for your help. :)

Posted: 18.05.2011, 23:42
by trupka
ahmed232323 wrote:it didn't work also ,it's will be good if there is class and it's members documentations to find options to added to the TZConnection.Properties
There is - download stable version from http://sourceforge.net/projects/zeoslib/files/ and take look inside parameters.pdf