Guest Posted August 14, 2005 Posted August 14, 2005 Hi all, how do you handle symbols like ' in your database ? The problem is, that if you export easy populate file, and then just try to upload it again, it will not do that... 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\\' extern, 2x 3,5\\'\\' extern, 5x 3,5\\'\\' intern # V?ha: ca. 12 kg INSERT INTO products_description (products_id, language_id, products_name, products_description, products_url, products_head_title_tag, products_head_desc_tag, products_head_keywords_tag) VALUES ( '979', 1, 'Aerocool AeroEngine Gamer Case Sr. - black', '# Velikost: 205 x 522 x 430mm (BxHxT) # Format: ATX nebo Micro ATX # P?edn? panel: Dual USB2.0, IEEE 1394 Firewire, Audio & Speaker ports, Fan Controller # Pozice pro v?tr?ky: 3x 80mm, 1x 120mm # Pozice: 5x 5,25\\'\\' extern, 2x 3,5\\'\\' extern, 5x 3,5\\'\\' intern # V?ha: ca. 12 kg ', '', '', '', '') any suggestions how to easily handle this ? :( Quote
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.