mORMot Open Source

array81

Member

From: Italy

Registered: 2010-07-23

Posts: 411

Change field format

Hi,

I have a table with a string field, this field have all float number convert to string as value.
Now I need convert this field (and all the record value) from string to double without change field name.

Is there a way to do it?

I have try to edit the database (create with the framework) with 3rd tools like Navicat but I get a message error: "no such collation sequence: SYSTEMNOCASE"

regards

Last edited by array81 (2014-04-30 07:54:43)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,661

Website

Re: Change field format

If you are using SQLite3 (as it sounds like), you can just change the field definition from RawUTF8 to double, and it may work.
By itself, SQLite3 has so-called "column affinity" - see http://www.sqlite.org/datatype3.html#affinity
Did you just try that?

As a tool, you may use SynDBExplorer to access the file directly.

array81

Member

From: Italy

Registered: 2010-07-23

Posts: 411

Re: Change field format

Yes I use SQLite, so I must only change the field definition on my code, right? Sound good!

Yes I use SynDBExplorer, it works well but sometimes I need of other tools like import data.
I have discovery SQLite Manager a extesion of FireFox (https://addons.mozilla.org/it/firefox/a … e-manager/) I think it support SYSTEMNOCASE besides allow to edit field format.

In any case I will try to edit field definition on my code. Thanks