Ready to give up on MySQL - is PostgreSQL better?
-
I am sick to the back teeth of encoding issues with MySQL. I have Googled the issue and tried every suggestion I can find, and am still plagued with insert errors such as:
ERROR [HY000] [MySQL][ODBC 5.1 Driver][mysqld-5.5.18]Incorrect string value: '\xEF\x82\xA7\x09Se...' for column '[column name]' at row 1
Please.. don't bother suggesting ways round this, I give up on it. My question, to anyone else who has experienced this, is simply this: does PostgreSQL suffer this same issue, or at least have a solution that works?
-
I am sick to the back teeth of encoding issues with MySQL. I have Googled the issue and tried every suggestion I can find, and am still plagued with insert errors such as:
ERROR [HY000] [MySQL][ODBC 5.1 Driver][mysqld-5.5.18]Incorrect string value: '\xEF\x82\xA7\x09Se...' for column '[column name]' at row 1
Please.. don't bother suggesting ways round this, I give up on it. My question, to anyone else who has experienced this, is simply this: does PostgreSQL suffer this same issue, or at least have a solution that works?
It will have different issues. Your best bet is to make sure you install it to use Unicode. But watch out, PostGreSQL uses UTF8 while dotnet uses UTF16 internally. So you might still encounter odd issues. MySQL supports UTF16 from version 5.5 IIRC. Why do you use odbc instead of Connector/NET?
Wrong is evil and must be defeated. - Jeff Ello[^]
-
It will have different issues. Your best bet is to make sure you install it to use Unicode. But watch out, PostGreSQL uses UTF8 while dotnet uses UTF16 internally. So you might still encounter odd issues. MySQL supports UTF16 from version 5.5 IIRC. Why do you use odbc instead of Connector/NET?
Wrong is evil and must be defeated. - Jeff Ello[^]
It was installed with utf8_geberal_ci as the default. With the later versions of MySQL supporting utf8mb4_general_ci I've tried that too - but to no avail. Why ODBC? Habit, I guess. Would Connector/NET make a difference?
-
It was installed with utf8_geberal_ci as the default. With the later versions of MySQL supporting utf8mb4_general_ci I've tried that too - but to no avail. Why ODBC? Habit, I guess. Would Connector/NET make a difference?
Wombaticus wrote:
Would Connector/NET make a difference?
Mostly performance, and a lot of it. Have you read this[^]?
Wrong is evil and must be defeated. - Jeff Ello[^]