MS SQL + Delphi not the correct codepage
Posted: 23.08.2011, 14:31
Dear sirs,
I'm using MS SQL with Cyrillic_General (cp1251) encoding and Delphi. When I'm going to select data, everything works fine, but the update results in writing badly encoded characters in DB. I'm already tried to use codepage=win, codepage=win1251, codepage=cp1251 (and tried the same with codepage_client). Trace shows that query arrives to the DB with already broken chars.
Example query on trace:
update tblEmployee set first_name='Николай' where empl_id=2
I'm using MS SQL with Cyrillic_General (cp1251) encoding and Delphi. When I'm going to select data, everything works fine, but the update results in writing badly encoded characters in DB. I'm already tried to use codepage=win, codepage=win1251, codepage=cp1251 (and tried the same with codepage_client). Trace shows that query arrives to the DB with already broken chars.
Example query on trace:
update tblEmployee set first_name='Николай' where empl_id=2