Saturday, February 17, 2007

Also the eye wants its part

Warning: this article has been modified on 7 February 2007.
You will have noticed that the fields of database Firebird 1.5.3 must have the form my_field or MYField and without accents or apex, or space as in "My Field".
We can instead give to the field the form which we want: that is "My Field" or "Citta'" or other type, if we set for the database, as character set, charset UTF8, and we can make it if we use an other free software of management for Firebird called FlameRobin 0.7.6 from here. Pay attention, in the query in, to the way as the fields of which has been spoken over, are written in a SQL statement: in order to make an instruction update example , the instruction must be written therefore: “update table set ""MY FIELD"" = 'Roma'", which is the field which must be all in capital, and this works even if the last letters of the field are accented or with apostrophe. FlameRobin is useful also because it gives, more of the other software, one information detailed on the errors in the query. It remains plain which, for the other uses are convenient the other software of management which I have indicated before.

No comments:

Post a Comment