Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

author
message
[Level:0]kshvakov

Post subject: Cubrid Shard and UTF8

registered: 06/20/2013

IP: *.226.189.236

views: 1

I use CAS_MYSQL

if insert cyrillic symbols  

 

Post пост

Error

(HY000)SQLSTATE[HY000]: General error: 1366 DBMS, Incorrect string value: 'xD0xBFxD0xBExD1x81...' for column 'title' at row 1

How to configure shard broker for support UTF8 character?

Quote
[Level:3]Esen Sagynov

# Post subject:Re: Cubrid Shard and UTF8

profile

registered: 05/31/2011

IP: *.91.139.82

Are you getting this error when using a particular driver? What driver are you using?

Quote
[Level:3]Esen Sagynov

# Post subject:Re: Cubrid Shard and UTF8

profile

registered: 05/31/2011

IP: *.91.139.82

By the way, what's the charset of your schema in MySQL?

Quote
[Level:0]kshvakov

# Post subject:Re: Cubrid Shard and UTF8

profile

registered: 06/20/2013

IP: *.226.189.236

on some servers set default charset = latin1

we fix scheme via cubrid broker applying ALTER + / * + shard_id () * /

 

Quote
[Level:3]Esen Sagynov

# Post subject:Re: Cubrid Shard and UTF8

profile

registered: 05/31/2011

IP: *.91.139.82

Ok, just to log things. The issue has been resolved. It occurred that on some machines/shards the default charset for MySQL was latin1 instead of UTF8. After changing to UTF8, the problem has been resolved.

The user has changed all schemas on all shards via a loop which executed ALTER TABLE ... /*+ shard_id($i) */ for each shard. Quite convenient, isn't it!?

Quote




You are either using a very old browser or a browser that is not supported.
In order to browse cubrid.org you need to have one of the following browsers:



Internet Explorer: Mozilla Firefox: Google Chrome: