473,323 Members | 1,551 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

Collate message

SG
Hi all,
Very new to MySql so I hope this is not too obvious!
I am getting the following error message when I am trying to load a
script ‘ERROR 1064 (00000) at line 20: 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 'collate latin1_bin default NULL
) ENGINE=MyISAM DEFAULT CHARSET'

I am using 4.0.18 do I need to modify the script? I've not found any
help in the manual either.

Many thanks
Sam
Jul 23 '05 #1
1 1474
On 19/04/2005, SG wrote:
Very new to MySql so I hope this is not too obvious!
I am getting the following error message when I am trying to load a
script ‘ERROR 1064 (00000) at line 20: 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 'collate latin1_bin default NULL
) ENGINE=MyISAM DEFAULT CHARSET'

I am using 4.0.18 do I need to modify the script? I've not found any
help in the manual either.


You need at least MySQL 4.1.1 for collations.

--
felix
Jul 23 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Nanchil | last post by:
Hi, We created a database (DB2 UDB 7.2 on solaris 8) without this (COLLATE USING IDENTITY ) option. But we need this now for binary sorting. The database is siebel database. Is it possible to drop...
1
by: Dag Henriksson | last post by:
I'm trying to compare strings written in Swedish using: std::locale loc(""); // System locale is Swedish loc(first, second); But this does not give me the right return value. for example, ...
0
by: Francisco Araujo | last post by:
I don't know if this is a bug or if i'm doing something wrong, but when the print dialog is shown on VB.NET and the user select multiple-copies and check the collate option and click ok, the...
3
by: Robert Liles | last post by:
I am using Visual Basic.NET 2002 and cannot get "collate" from the PrintDialog1 or e.PageSettings.PrinterSettings.Collate to return anything but "False." What am I doing wrong? I am using...
0
by: Robert Liles | last post by:
If I check the "Collate" box in the PrintDialog it is ignored, always returns "False" and does not collate. If I add the line " e.PageSettings.PrinterSettings.Collate = True" in my print routine,...
1
by: Zengfa Gao | last post by:
Hi, all: I have a schema definition, worked fine for PostgreSQL 7.2 and 7.3. But I saw errors when I use it on PostgreSQL 7.4. Can anyone tell me what's changed in 7.4? Thanks a lot!
0
by: Ron Adam | last post by:
I've made a few more changes to my little collate module. There might be better ways to handle the options, or better choices for the options themselves. I tried to keep it as general as...
1
by: mabubakarpk | last post by:
HI. I am using SQL Server 2000. I generate a script of some table from EmpDB database when I run script in query analyzer it return error "Incorrect syntax near 'COLLATE'." Scripts is ...
1
by: baburk | last post by:
CREATE TABLE Employees( EmployeeID int IDENTITY(1,1) NOT NULL, LastName nvarchar(20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL) What is use of Collate. In what are all the places can we...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.