Hi there,
I want to make a spell-checker for Georgian language, so at first I want to make some data from Georgian e-books. I tried to get some words from those books, but even for 49 000 word it is not enough. I used 1 database, 1 table and 1 column.
so if you can, tell how many rows can I add in one column(I use nchar (25)), what is the limit of tables in one database. I need about 10, 000, 000, 000 words in my database. thanks :)
Iftikar HussainPosted Jul 18, 2013, 11:36 PM
There is no limit for table. It is completely depend on your database size. But I suggest to use nvarchar(25) instead of nchar(25). Since nchar is fixed length unicode string. Therefor if word is less than 25 still it will occupy 50 bytes.
Refer the below link for the difference of nchar and nvarchar
http://msdn.microsoft.com/en-us/library/ms186939.aspx
Regards,
Iftikar
Jignesh TrivediPosted Jul 18, 2013, 11:02 PM
hi,
As per my knowledge, there is no such limit to inserting row with in table. we can say rows per table limited by available storage.
Please refer
http://msdn.microsoft.com/en-us/library/ms143432.aspx
hope this will help you.