allow writing of double-wide characters to database
Posted: 20.03.2008, 21:17
I am getting an error message "invalid byte code for utf-8" when trying to post a double-wide character to a PostGreSQL database in Delphi 2006.
I have read that there is a patch available for versions of Zeos a little bit newer than mine that fixes this problem. Upgrading Zeos versions sounds like a big pain, so I want to make sure that this patch covers every situation. Does it
- allow me to write double-wide characters into a database
- allow me to use a query object with an SQL statement that is looking for a double wide character
- display double wide characters from the database correctly in data aware controls, especially grids
- display a string from the database correctly in any control without using a conversion routine
I have figured out how to do everything except the data aware controls using the Delphi functions UTF8Encode and UTF8Decode. I could replace my data aware text boxes with regular textboxes, but the data aware grid is a showstopper.
I have read that there is a patch available for versions of Zeos a little bit newer than mine that fixes this problem. Upgrading Zeos versions sounds like a big pain, so I want to make sure that this patch covers every situation. Does it
- allow me to write double-wide characters into a database
- allow me to use a query object with an SQL statement that is looking for a double wide character
- display double wide characters from the database correctly in data aware controls, especially grids
- display a string from the database correctly in any control without using a conversion routine
I have figured out how to do everything except the data aware controls using the Delphi functions UTF8Encode and UTF8Decode. I could replace my data aware text boxes with regular textboxes, but the data aware grid is a showstopper.