IBLOCAL: Cannot transliterate char between character sets!

IBLOCAL: Cannot transliterate char between character sets!

Post by Thomas KIRCHT » Wed, 09 Oct 1996 04:00:00

Could anybody please tell me how to use special characters in IB Tables?
I tried using iso8859_1 (collate de_de), dos850 and none (That's ANSI I
suppose) but
whenever I use german Umlauts in the table (Inserted with Interactive SQL)
Delphi tells me "Cannot transliterate character between character sets".
Even stranger results with DB explorer. I can enter records with umlauts
and the status line tells me the correct number of records, but I can't
see them anymore (the result sets are empty). In ISQL they are still visible.
Delphi can't even open the table (with above error).
I used to think that's what iso8859_1 was there for ?

Thanks for any hints


* Thomas Kirchtag                                                     *
* TU-Vienna                                                           *
* Institute of General Chemistry                                      *
* Chemometrics Department                                             *
* Lehargasse 4/152                                                    *
* A-1060  Wien                                                        *

*                          http://echm10.tuwien.ac.at/inst/tk/tk.html *
"Bear-naard? Sometimes I smoke after I make love."
"I can believe it," I said. "Oh. You mean a cigarette."
               Lawrence Block - The burglar who thought he was Bogart


1. char, nchar and unichar, default character set and unicode - utf-8 and utf-16

Hi all,

Based on what I saw from Sybase manual/documants, char is one byte
long and can only store English; nchar is multi-bytes and can store
other languages, for example, Asian Language; unichar is for UTF-16
encoding of Unicode, always use 2-bytes for a character. For using
unichar, the default character set must be UTF-8. For using nchar to
represent Asian language, we must choose the proper character set as

However, when I try to test inserting/selecting foreign language with
default character set of iso_1(character set ID=1), I got correct
result, no funny character. Here is what I did:

1. the default character set on ASE is iso_1
2. the client is windows2000, which support multiply language.
3. create a table with two column, one is char, another is nchar.
4. insert into the table with asian language for both columns.
5. select them to display on client machine.

My questions are

1. Why can I insert and display Asian language with char and nchar but
default character set is iso_1?

still one byte, because default character set is iso_1. If I choose
another character set, is there any difference between char and nchar?

Thank you in advance.


2. working directory

3. Non supported character set: oracle-character-set-96

4. prb vb4 16-bit data control dropdown listbox / dbcombo

5. db character set & N character set

6. Link Problem

7. Cannot find the requested character set in Syscharsets

8. Table Creation Help

9. Characters beyond ASCII in database ( US7ASCII and UTF8 character set )

10. Character set and set order in SQL Server 6.5

11. Setting the Oracle character set

12. Change set order and character set in SQL 6.5

13. How to get/set character set?