Why ≥ character not displayed in ISQL?

[Former Member]

How can I display those characters displayed?

[reimer_pods]

Can you give us some more details to your question: what SA and ISQL version are you using, in which context (OS, language) and what are you trying to do (e.g. SQL statement)?

[Former Member]

I have a column and stored a ≥ character, but it displays a square, instead of ≥ in the ISQL. The version I am using is v12.

[johnsmirnios]

What database collation & charset is being used? How was the data inserted?

[Former Member]

It could also be a font issue. If the font you're using doesn't have an entry for the character, it will typically display it as a box. What OS are you using?

Can the SQL Statements area show the character correctly? Or is it just messed up in the results view?

[Former Member]

The Collation is 1251LATIN1, Charset is windows-1252. I pasted the character into the field. I am using Windows XP.

[Former Member]

So, what should I do?

[johnsmirnios]

If you want to store that character, you need to use a character set & collation that supports it. The UTF8BIN and UCA collations both support the UTF-8 character set that can encode all of Unicode. To change your database collation, you must unload your database, create a new one with the correct collation and then reload the data.

Also note that on your OS that uses windows-1252, only Unicode applications will be able to display the character. So dbisql will be able to show it but dbisqlc will not. Non-unicode apps on Windows can only deal with the OS charset.

[johnsmirnios]

The '≥' is not representable in code page 1251 or 1252 therefore it was replaced with a substitution character when you inserted it. You can peruse the character sets here: http://demo.icu-project.org/icu-bin/convexp. Specifically, windows-1251 is here: http://demo.icu-project.org/icu-bin/convexp?conv=ibm-5347_P100-1998&s=ALL and windows-1252 is here: http://demo.icu-project.org/icu-bin/convexp?conv=ibm-5348_P100-1997&s=ALL

-john.