Re: [GENERAL] database design and refactoring

2007-01-04 Thread Erik Jones
Michael Glaesemann wrote: On Jan 3, 2007, at 5:24 , Luca Ferrari wrote: And moreover a database design question: is a better idea to choose always (when possible) numeric keys? Depends on your requirements. This is an oft-discussed topic about which you can find many more opinions by googli

Re: [GENERAL] database design and refactoring

2007-01-04 Thread Michael Glaesemann
On Jan 3, 2007, at 5:24 , Luca Ferrari wrote: Running the database, the users decided to place numbers as strings, so values like 00110002 and so on. Note that '00110002' is not a number (i.e., it's not equal to 110002): it's a string of digits. is there a tool or a way to easily do su

[GENERAL] database design and refactoring

2007-01-03 Thread Luca Ferrari
Hi all, in my database I've got a table with a key that is char string, since it was supposed to support values like strings. Running the database, the users decided to place numbers as strings, so values like 00110002 and so on. Now I was wondering to refactor my database and change the char fie