Data Types?

[aldi]

Please help!!!
Can anybody please tell me what data type to use to save RTFText from a rich text format box and if posible to let me know where to find info about PervasiveSQL 2000 data types?

Thanks in advance!!!

 

[zemp]

You can go to this page and do a search for data types.

http://www.pervasive.com/library/index.asp?_portal=VISUALBASIC

Thanks and Good Luck!

zemp

 

[mirtheil]

Are you using Btrieve or ODBC to insert/read the data? If you're using ODBC, I would probably suggest a LongVarChar or a LongVarBinary. If you're using Btrieve, I would suggest a variable length file, in terms of Btrieve, and then store the RTF data in the variable portion.
That being said, I would almost store the RTF in it's own file and then place a link to the filename in the Btrieve file.
info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[aldi]

Hi zemp, thank you for the link.

Hi mirtheil, I'm using ODBC and the connection is read/write.

What would be the difference when using either longvarchar or longvarbinary???

thanks a lot!!

 

[mirtheil]

LongVarChar would be used to store strictly character data. If there's a chance that binary data would be stored, even if it's something like a carriage return or other non-printable character, you should use LongVarBinary.
As far as using the two data types, there wouldn't be a difference. I would still strongly recommend using a link in the Btrieve file and storing the RTF in it's own file.
info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician