Inserting string with special character in database.

rubyonrails-talk
1

Quoting Anubhaw Prakash <rails-mailing-list@andreas-s.net>:

Hi all. I am having trouble in reading string containing special characters from file and storing them in database. For example, for string like '\x89\xA5\xCFI w...' it throws error "Incorrect string value". The string should be wrappped in duoble quotes, but i didn't find any method to do so. If any one has solution please help. I need it very badly.

Which database and what character set, e.g. UTF-8, Latin1, ASCII? Rails now defaults to UTF-8, but most databases default to Latin1.

Jeffrey

2

Quoting Anubhaw Prakash <rails-mailing-list@andreas-s.net>:

Jeffrey L. Taylor wrote: > Quoting Anubhaw Prakash <rails-mailing-list@andreas-s.net>: >> >> Hi all. >> I am having trouble in reading string containing special characters from >> file and storing them in database. For example, for string like >> '\x89\xA5\xCFI w...' >> it throws error "Incorrect string value". The string should be wrappped >> in duoble quotes, but i didn't find any method to do so. If any one has >> solution please help. I need it very badly. > > Which database and what character set, e.g. UTF-8, Latin1, ASCII? Rails > now > defaults to UTF-8, but most databases default to Latin1. > > Jeffrey

Database is MySql and character set is UTF-8 default.

Anubhaw Thanks.

The first character is a control code in UTF-8, HTJ. I've tried assigning and saving the above character strings in the Rails console. The saved and retrieved string is empty, but I'm not seeing the error "Incorrect string value". What is throwing this error? I also don't understand the part about wrapping in double quotes. Why can't you modify your program to change single to double quotes?

Jeffrey

3

Jeffrey L. Taylor wrote:

Quoting Anubhaw Prakash <rails-mailing-list@andreas-s.net>:

>> solution please help. I need it very badly. Thanks.

The first character is a control code in UTF-8, HTJ. I've tried assigning and saving the above character strings in the Rails console. The saved and retrieved string is empty, but I'm not seeing the error "Incorrect string value". What is throwing this error? I also don't understand the part about wrapping in double quotes. Why can't you modify your program to change single to double quotes?

Jeffrey

Hi Jeffrey, Your question solved my trouble. I set the database character set to Latin1 and it worked. It took the string with special character in DB.

Thanks.