Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 03-22-2021 11:37:14

Registered: 01-24-2018
Posts: 40

text field types in database


We have our own local system that stores customer and product data locally and a colleague of mine is in the process of developing methods of uploading product data directly from our local database files to the online database used by Kryptronic.

We have come across some difficulties, mainly to do with field types and some of them being of type text. For example in ecom_pricemap, regprice and whlprice  are text fields not varchar. It seems a bit over the top especially since varchar can now be the same length as a text field.

Is there any plan to change these fields and would there be an impact if they were?



#2 03-23-2021 10:17:03

From: York, PA
Registered: 04-20-2001
Posts: 19717

Re: text field types in database

You could technically change those text fields to varchars, but be careful to ensure your varchar fields can support large amounts of text.  Both regprice and whlprice support volume based pricing, so those fields may contain well over 255 characters.  Use ALTER TABLE commands to change them, if you decide to.  K9 will work just fine.

Nick Hendler



Board footer