[firebird-support] Chararacter set NONE to ISO8859_1
Hi, I have some VARCHAR fields whose character set were incorrectly defined as NONE. I would like to use ISO8859_1 instead. I read on The Firebird Book that in order to do so you must add a new temporary field, with the right character set, fill it with the data from the original field ( using OCTECT as an intermediat chararacter set ) and finally drop and recreate the original field with the right character set, filling it with the data that was stored in the temporary field. The process ends up dropping the temporary field. I wonder what is wrong with simply invoking ALTER TABLE X ALTER COLUMN Y TYPE CHAR(N) CHARACTER SET ISO8859_1 Thanks in advance for any help. Aldo Caruso ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) * To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com * To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com * Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] Re: Firebird 1.5.3 on Windows 2012 R2 Server
Mike wrote: Can anyone tell me if Firebird 1.5.3 will run on Windows 2012 R2 Server? The silence might mean that you are the first (on this list) wanting to run the ancient 1.5.3 on a Windows2012R2 server. Try it, and report back. -- Aage J.
[firebird-support] normalization and placeholder
Hello, currently I save a path to a picture like this in my database: s:\20150201101005_1\r0001.tif - firebird 2.5 But this path I can compose from the other informations. First I have a timestamp 2015-02.,, _1 is the line where it is created, 1 is the picture Number. Now I would create a config Table with which I can set the Path dynamically. If there a change, I can create a new configuration an set it to the picture. But how could I save this configuration? S:\ || :TimestampVar || _ || :linevar ,,, Is there only possible with an sql statement (set the String in a procedure and execute statement..) How can I realize this? There are more options? Thanks in advance Best regards Olaf
