The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

How can I display those characters displayed?

asked 28 Nov '12, 11:03

pLee's gravatar image

pLee
21691119
accept rate: 0%

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

(28 Nov '12, 11:09) Reimer Pods

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.

(28 Nov '12, 14:49) pLee
Replies hidden

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

(28 Nov '12, 17:05) John Smirnios

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?

(28 Nov '12, 17:15) Phil Mitchell

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

(28 Nov '12, 18:25) pLee

So, what should I do?

(29 Nov '12, 12:52) pLee
Replies hidden
1

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.

(29 Nov '12, 13:13) John Smirnios
showing 4 of 7 show all flat view

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.

permanent link

answered 28 Nov '12, 21:31

John%20Smirnios's gravatar image

John Smirnios
8.7k377106
accept rate: 40%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×13

question asked: 28 Nov '12, 11:03

question was seen: 853 times

last updated: 29 Nov '12, 13:24