Hello everyone
I'd like to ask how do you deal with case sensitive name queries from different dicom clients. For example:
Patient name in my pg database looks like this: "John Smith"
Let's say doctor typed in "smith" and hit search button.
Now, depending on the viewer, there are few cases:
1) some dicom viewers ( like Efilm for example) ask for "SMITH" (to be more precise: ...WHERE DICOMStudies.PatientNam LIKE E'SMITH%'...)
2) other viewers (like Radiant) leave everything as it was so it'll ask for "smith"
so.. they both return 0 results.
For now I can't even be sure if the name format in my db is always consistent/correct - 99% of the time study is made based on worklist entry so it'll be like 'John Smith' but sometimes sth goes wrong and study is made manually.. so I can not guarantee that someone didn't type in "John SMITH' for example.
This can be easily fixed by ImportConverter using '^' ... so let's say I'll use it to guarantee that ALL entries in db will be in upper cases.
Case 1 fixed.. but what about case 2?
Can I force Conquest to always ask db for upper('smith')? as in ...WHERE DICOMStudies.PatientNam LIKE upper(E'smith%')\
or
can I modify incoming c-find and replace 'smith' with 'SMITH' on the fly?
or
maybe there is another easy solution I can't see?