Encodeing problem

[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 to learn more about this language is depend on this

[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

[ahmed232323]

Hello, Wild_Pointer
thanks for your speedy reply.

May it be that you have forgoten to add codepage=utf8 in the properties of TZConnection?

I didn't find codePage property in TZConnection?.

[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.

[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.

[trupka]

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