sql database raw limit

Question

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 Hussain · Answer

Hi 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 Trivedi · Answer

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.