December 29th, 2012, 04:41 PM
|
|
Registered User
|
|
Join Date: Dec 2012
Posts: 2
Time spent in forums: 20 m 57 sec
Reputation Power: 0
|
|
|
MySQL script/encoding/command line problem
I would love for someone more knowledgeable than me to point out what the %¤&/ I am doing wrong trying to test an MySQL script on the command line:
Code:
drop database movies;
create database movies;
use movies;
create table movie (
id int not null auto_increment,
title varchar(50),
year int,
price decimal(8,2),
primary key(id)
);
insert into movie (title,year,price) values (”The Great Race”, 1965, 12.95);
Completely irrespectively of what I do, no matter which file format I try to store the script in, no matter which encoding I attempt, I always get the same error message:
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 'öThe Great Raceö, 1965, 12.95)' at line 1
Of course, the 'ö' can be traded for a number of other erroneous characters depending on the file format/encoding of the source file, but never the right one, double quotation marks as in the source file itself.
Big up to anyone who can his provide any answers or pointers to where I can read up on this specific problem.
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
