Hi Elpidio, I've talked with my sister (she is a doctor) and I have came to the best solution. Since they do wright all the diagnoses in Latin, I have copied the Bosnian/Serbian/Croatian (all the same language) into notes column. I have also made a small change to the sql string in IDC page, responisble for searching of the dignosis and codes, and added the "notes" into the search criteria, so the people can also search notes. This works. I have also managed to export all the language special characters.
There is one more thing, about 50 of the last codes are not in latin, so in that case I will have to copy the bosnian into latin (just for the last 50). Thanks for your help Do you have some sort of normal email address so that I can send you the latin and bosnian idc as sql? regards, emir > Hello Emir, > > I think I understand now why you were thinking of putting both the bosnian > and > latin text together in one column. I have discussed this with one of my > colleagues who comes from the same country and he told me that you are > using > in medicine more latin words than your own language and you are using more > latin than any other country. > > Considering that fact, you might be right in putting both text versions > together in one column. This way, the user can input the search keyword in > either bosnian or latin and still gets the most probable correct result. > > So you can produce 3 versions of the ICD data: > > a) bosnian only > b) latin only > c) latin + bosnian > > And the user will just decide which version is the right one to install. > > Just try it. I personally think your idea is a good one. > > Regards, > Elpidio > > On Monday 21 June 2004 14:09, Emir Prcic wrote: > > I need to have > > codes in both languages (latain and bosnian) and they need to be > > individualy searchable. What do you propose, to combine/have two > languages > > in one column, like this(a00 = cholera / kolera), > > > > ------------------------------------------------------- > This SF.Net email sponsored by Black Hat Briefings & Training. > Attend Black Hat Briefings & Training, Las Vegas July 24-29 - > digital self defense, top technical experts, no vendor pitches, > unmatched networking opportunities. Visit www.blackhat.com > _______________________________________________ > Care2002-developers mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/care2002-developers > -- "Sie haben neue Mails!" - Die GMX Toolbar informiert Sie beim Surfen! Jetzt aktivieren unter http://www.gmx.net/info ------------------------------------------------------- This SF.Net email sponsored by Black Hat Briefings & Training. Attend Black Hat Briefings & Training, Las Vegas July 24-29 - digital self defense, top technical experts, no vendor pitches, unmatched networking opportunities. Visit www.blackhat.com _______________________________________________ Care2002-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/care2002-developers