RE: Handling Special Characters

2008-01-21 Thread Jerry Schwartz
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 Schwartz [EMAIL PROTECTED] wrote: I am

RE: Handling Special Characters

2008-01-21 Thread Jerry Schwartz
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 seems

Re: Handling Special Characters

2008-01-20 Thread Sebastian Mendel
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

RE: Handling Special Characters

2008-01-19 Thread Jerry Schwartz
-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 18, 2008 2:27 PM, Jerry Schwartz [EMAIL

Re: Handling Special Characters

2008-01-18 Thread Baron Schwartz
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 line