Re: [GENERAL] converting databases form SQL_ASCII to UTF8

2011-05-03 Thread Jasen Betts
On 2011-04-22, Geoffrey Myers g...@serioustechnology.com wrote: Vick Khera wrote: On Fri, Apr 22, 2011 at 11:00 AM, Geoffrey Myers li...@serioustechnology.com mailto:li...@serioustechnology.com wrote: Here's our problem. We planned on moving databases a few at a time. Problem is,

Re: [GENERAL] converting databases form SQL_ASCII to UTF8

2011-05-03 Thread Geoffrey Myers
Jasen Betts wrote: On 2011-04-22, Geoffrey Myers g...@serioustechnology.com wrote: Vick Khera wrote: On Fri, Apr 22, 2011 at 11:00 AM, Geoffrey Myers li...@serioustechnology.com mailto:li...@serioustechnology.com wrote: Here's our problem. We planned on moving databases a few at a time.

Re: [GENERAL] converting databases form SQL_ASCII to UTF8

2011-04-30 Thread Dimitri Fontaine
Geoffrey Myers li...@serioustechnology.com writes: So, now the question is, is this effort even worth our effort? What is the harm in leaving our databases SQL_ASCII encoded? You're declaring bankruptcy on being able to make any sense of the data you stored. Is that really what you think you

[GENERAL] converting databases form SQL_ASCII to UTF8

2011-04-22 Thread Geoffrey Myers
We are moving our databases to new hardware soon, so we felt it would be a good time to get the encoding correct. Our databases are currently SQL_ASCII and we plan to move them to UTF8. So, as previously noted, there are certain characters that won't load into a UTF8 database from a dump of

Re: [GENERAL] converting databases form SQL_ASCII to UTF8

2011-04-22 Thread Vick Khera
On Fri, Apr 22, 2011 at 11:00 AM, Geoffrey Myers li...@serioustechnology.com wrote: Here's our problem. We planned on moving databases a few at a time. Problem is, there is a process that pushes data from one database to another. If this process attempts to push data from a SQL_ASCII

Re: [GENERAL] converting databases form SQL_ASCII to UTF8

2011-04-22 Thread Adrian Klaver
On Friday, April 22, 2011 8:00:08 am Geoffrey Myers wrote: What is the harm in leaving our databases SQL_ASCII encoded? SQL_ASCII is basically no encoding. The world is slowly but surely moving to Unicode, sooner or later you are going to hit the unknown encoding/Unicode wall. Probably

Re: [GENERAL] converting databases form SQL_ASCII to UTF8

2011-04-22 Thread Vick Khera
On Fri, Apr 22, 2011 at 11:16 AM, Geoffrey Myers g...@serioustechnology.com wrote: Totally agree. Still, the question remains, why not leave it as SQL_ASCII? you have no guarantees that the data stored within is utf-8. that is all. if you can make such guarantees from within your

Re: [GENERAL] converting databases form SQL_ASCII to UTF8

2011-04-22 Thread Geoffrey Myers
Vick Khera wrote: On Fri, Apr 22, 2011 at 11:00 AM, Geoffrey Myers li...@serioustechnology.com mailto:li...@serioustechnology.com wrote: Here's our problem. We planned on moving databases a few at a time. Problem is, there is a process that pushes data from one database to

Re: [GENERAL] converting databases form SQL_ASCII to UTF8

2011-04-22 Thread Rob Sargent
On 04/22/2011 09:16 AM, Geoffrey Myers wrote: Vick Khera wrote: On Fri, Apr 22, 2011 at 11:00 AM, Geoffrey Myers li...@serioustechnology.com mailto:li...@serioustechnology.com wrote: Here's our problem. We planned on moving databases a few at a time. Problem is, there is a process that

Re: [GENERAL] converting databases form SQL_ASCII to UTF8

2011-04-22 Thread Eric McKeeth
On Fri, Apr 22, 2011 at 9:16 AM, Geoffrey Myers g...@serioustechnology.comwrote: Vick Khera wrote: The database's enforcement of the encoding should be the last layer that does so. Your applications should be enforcing strict utf-8 encoding from start to finish. Once this is done, and the

Re: [GENERAL] converting databases form SQL_ASCII to UTF8

2011-04-22 Thread Steve Crawford
On 04/22/2011 08:00 AM, Geoffrey Myers wrote: We are moving our databases to new hardware soon, so we felt it would be a good time to get the encoding correct. Our databases are currently SQL_ASCII and we plan to move them to UTF8. We are in the same boat, fortunately only on one older server