Thread: Character problems

Character problems

From
Ferdinand Smit
Date:
Hi,

I have a problem with inserting/updating "strange" characters. I can only use
strange characters at the beginning of a string. The select statement has'nt
this problem.

Is this a bug or am i doing something wrong ?

Regards,
Ferdinand


Example:

db=> select '\353x';
 ?column?
----------
 ëx
(1 row)

db=> select 'xx\353x';
 ?column?
----------
 xxëx
(1 row)

db=>
db=> insert into x values ('\353x');
INSERT 4284014 1
db=> insert into x values ('xx\353x');
INSERT 4284015 1
db=> select * from x;
  t
-----
ëx
x
(2 rows)

db=>


Re: Character problems

From
Ferdinand Smit
Date:
Hi,

After a few tests my conclusion is:
- This problem only accist if you use UNICODE and use a char record
(SQL_ASCII works fine).
- I think the problem is that de character counter count special characters
differend from normal characters. It only occur when you insert a string
which size is (almost) the same as the record size.

Ferdinand