Encodeing problem

Forum related to MS SQL Server

Moderators: gto, cipto_kh, EgonHugeist

ahmed232323
Fresh Boarder
Fresh Boarder
Posts: 3
Joined: 16.05.2011, 20:43

Encodeing problem

Postby ahmed232323 » 16.05.2011, 21:19

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

Wild_Pointer
Expert Boarder
Expert Boarder
Posts: 162
Joined: 18.03.2008, 13:03
Contact:

Postby Wild_Pointer » 17.05.2011, 07:54

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
Fresh Boarder
Fresh Boarder
Posts: 3
Joined: 16.05.2011, 20:43

Postby ahmed232323 » 17.05.2011, 20:46

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

Wild_Pointer
Expert Boarder
Expert Boarder
Posts: 162
Joined: 18.03.2008, 13:03
Contact:

Postby Wild_Pointer » 18.05.2011, 07:18

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
Fresh Boarder
Fresh Boarder
Posts: 3
Joined: 16.05.2011, 20:43

Postby ahmed232323 » 18.05.2011, 21:26

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
Expert Boarder
Expert Boarder
Posts: 140
Joined: 26.08.2007, 22:10

Postby trupka » 18.05.2011, 23:42

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


Return to “MS SQL Server”

Who is online

Users browsing this forum: No registered users and 1 guest