Forum Moderators: open
I am trying to do the following and need some help.
I am trying to make a table with a million items in it (x) with various fields (abc)
table Web
#*$!#*$!#*$!#*$!#*$!#*$!#*$!#*$!#*$!#*$!#*$!#*$!
A
A
A
B
B
B
C
C
C
however , mysql does not let me upload the data as it is to big , so i try to use big dump and it came back with the following error : database charset is not Latin.
the data looks like the following :
1google.com
2yahoo.com
3youtube.com
4aol.com
5wikipedia.org
my questions are the following :
1. What does Latin charset look like ?
2. Does mysql allow large datasets or is there another database to use ?
Regards
Nowadays, we are more and more using the UTF-8 charset to store data. Then, for your information (since you use dump), I use the following MySQL statement to force MySQL to use the charset you want.
$connect=@mysql_connect("$server","$user","$pass") or die ("Unable to connect server");
$db_select=@mysql_select_db("$database") or die ("Unable to get table");
mysql_query("SET CHARACTER SET utf8");
mysql_query("SET NAMES utf8");Yes, I guess mysql allow large datasets but you need to optimise it for better results (From easy setting - reduce charvar, do not use text, use NULL if possible, etc. - To advanced settings - explain SQL, play with MySQL cache settings, etc.)
