On 16 Jul 2013, at 12:26pm, Bernd Lehmkuhl <bernd.lehmk...@email.de> wrote:
> The actual table definition is : > CREATE TABLE T_VWG_ABFALLVERZEICHNIS (SCHLUESSEL String, BESCHREIBUNG String, > BEMERKUNG String, ID_GUID String, IST_PAUSCHALIERT String, > IST_KATEGORIE_ESK_BETRIEBSSTOF String); You have found your problem. The type 'String' is not supported by SQLite. It interprets the word according to some rules which result with INTEGER columns. And since "01" can be interpreted as an integer it accepts that it is an integer. If you can arrange for this table to be defined like this: > CREATE TABLE T_VWG_ABFALLVERZEICHNIS (SCHLUESSEL TEXT, BESCHREIBUNG TEXT, > BEMERKUNG TEXT, ID_GUID TEXT, IST_PAUSCHALIERT TEXT, > IST_KATEGORIE_ESK_BETRIEBSSTOF TEXT); the problem you reported will not happen. Unfortunately there is no easy way in SQLite to change the affinity of a column. You can only drop the table and create a new one. I agree with you that Joe Mistachkin is probably going to be the best provider of a proper official solution. Viel Glück mit ihm. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
