looks like a Unicode problem and your 'smart quotes' are not supported in the ASCII-style text field... in SQL Server 2000 have you tried setting the type to ntext rather than text?
- James Macpherson -----Original Message----- From: Adam Chapman [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 1:21 PM To: CFAussie Mailing List Subject: [cfaussie] Single/Double quotes into SQL Server I have a problem with SQL 2000, it keeps converting double and single quotes to some weird characters. I am simply copying text from a Text file into a form field and submitting. Text Field 16 ======= THIS IS WHAT I SUBMIT ======= “I wasn’t expecting it at all, but then again once you’re in the initial squad you’re in with a chance,” the apprentice electrician said. “I’ve been fairly happy with how I’ve been riding and, after a few weeks off recently to recharge the batteries, I’m feeling better than ever. ======= THIS IS WHAT IS STORED ======= “I wasn’t expecting it at all, but then again once you’re in the initial squad you’re in with a chance,†the apprentice electrician said. “I’ve been fairly happy with how I’ve been riding and, after a few weeks off recently to recharge the batteries, I’m feeling better than ever. Anyone know of a fix, a few UDFs ive tried don’t seem To have any effect. Kind Regards Garry Morrow M a v e r i c k D e s i g n http://www.maverickdesign.com.au Email: [EMAIL PROTECTED] Phone:(03) 9879 3919 Fax: (03) 9879 4319 Mobile: 0419 106 330 b.���\ &v\ }'9r^'rᲷ+}Ყ-fNrzǧujy 器^j}諬'^}+-֞ܢf1p{u &i*'iv'( b����.����\��� �&�v� }���'���܆+ޙ��j�!����d�{.n�+���zwZnV��隊[h��y�ں�"{~��Ib�� i騝�&j��'�w^� "h�� �¢xm����nr��
