Re: Embedded Quotes and Special Characters.

2005-01-05 Thread Gleb Paharenko
Hello. See: http://dev.mysql.com/doc/mysql/en/Charset.html Andrew Mull <[EMAIL PROTECTED]> wrote: > That is what I was wondering, but not sure how to check/set the proper > character set. > > Thanks. > > -Andy > > Quoting Gleb Paharenko <[EMAIL PROTECTED]>: > >> Hello. >>

Re: Embedded Quotes and Special Characters.

2005-01-04 Thread Andrew Mull
On other instances, " are escaped as \"...I would think that should translate correctly? Thanks Quoting Andrew Mull <[EMAIL PROTECTED]>: > When I look at the dump file, I see that one of the invalid characters is > represented as /226 I'll have to look to see if it is consistent, and just >

Re: Embedded Quotes and Special Characters.

2005-01-04 Thread Andrew Mull
When I look at the dump file, I see that one of the invalid characters is represented as /226 I'll have to look to see if it is consistent, and just replace it. Thanks. Quoting [EMAIL PROTECTED]: > are you sure that the single/double quotes in your original data were > actually the standard

Re: Embedded Quotes and Special Characters.

2005-01-04 Thread Andrew Mull
That is what I was wondering, but not sure how to check/set the proper character set. Thanks. -Andy Quoting Gleb Paharenko <[EMAIL PROTECTED]>: > Hello. > > You can write a script which will walk through all tables and > update the rows using replace() function. But, I think, you should > fin

Re: Embedded Quotes and Special Characters.

2005-01-04 Thread Gleb Paharenko
Hello. You can write a script which will walk through all tables and update the rows using replace() function. But, I think, you should find the source of the problem. What odd characters have appeared after importing? If they are just unreadable, may be the clue is in wrong character set.