Database Forum
Web Database Register Members List Calendar FAQ

 
Go Back   Database Forum > Other Database Software > Convert access & excel to the web
User Name
Password

Reply
 
Thread Tools Search this Thread Display Modes
Default Error Excel to MySQL
01-19-2010, 06:55 PM #1  

sal311595
Junior Member

 
Status: Offline
Posts: 4
Join Date: Jan 2010

Hello, I am new in this forum.

Trying to upload a file that I convert to mysql and I get the folllowing error in my server:

Error
SQL:

default - character - SET = latin1default - COLLATION = latin1_swedish_ci

MySQL :

#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 'default-character-set=latin1
default-collation=latin1_swedish_ci' at line 1

How Can I import it to my server ????

Thank you in advance

Sal
Reply With Quote

Default
01-20-2010, 06:57 AM #2  

clifford
Senior Member

 
Status: Offline
Posts: 266
Join Date: Mar 2005
Location: San Fran, CA

Verify that this database was created as 'character-set=latin1 default-collation=latin1_swedish_ci' if not you may have a conflict there.
Reply With Quote

Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump



All times are GMT -5. The time now is 04:46 PM.

Powered by: vBulletin Version 3.7.4
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Database Forums

Help support our forum assistants and product development ->

go to top go to top