This isn't really a problem with MySQL; MySQL just trips on it.
Let me caution you that this discussion applies to Windows. I did observe
this in my applications on Linux, but the problem will show itself only when
reading a file, whether uploaded or not; there will be no problem if the
data is en
> use UTF-8 for text files
> use SET NAMEs to correctly MySQL what charset you are using
>
>
>
> --
> Sebastian
[JS] You are correct. The results were very confusing, especially since the
visual difference between a hyphen (0x2D) and an N-quad (0x96). Also,
copying UTF-8 text to a command window s
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of Baron Schwartz
> Sent: Friday, January 18, 2008 2:33 PM
> To: Jerry Schwartz
> Cc: mysql@lists.mysql.com
> Subject: Re: Handling Special Characters
>
> Jerry,
>
> On Jan 18, 2008 2:27 PM, Jerry Schwar
Jerry Schwartz schrieb:
I am having trouble inserting special characters into a table. I am using
the MySQL client. I put the following commands into a text file (I'm on
WinXP, using Notepad), copy them, and paste them into the MySQL command line
client.
SET NAMES utf8;
CREATE TEMPORARY TABLE `
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of Baron Schwartz
> Sent: Friday, January 18, 2008 2:33 PM
> To: Jerry Schwartz
> Cc: mysql@lists.mysql.com
> Subject: Re: Handling Special Characters
>
> Jerry,
>
> On Jan
Jerry,
On Jan 18, 2008 2:27 PM, Jerry Schwartz <[EMAIL PROTECTED]> wrote:
> I am having trouble inserting special characters into a table. I am using
> the MySQL client. I put the following commands into a text file (I'm on
> WinXP, using Notepad), copy them, and paste them into the MySQL command
I am having trouble inserting special characters into a table. I am using
the MySQL client. I put the following commands into a text file (I'm on
WinXP, using Notepad), copy them, and paste them into the MySQL command line
client.
SET NAMES utf8;
CREATE TEMPORARY TABLE `giiexpr_db`.`eo_name_table