db int filed used as text

1 Dec
2009
1 Dec
'09
11:26 a.m.
Hi, In my db the customer login field is an integer, but apparently when otrs runs query on the customer_user table it uses the login field as text thus slowing down all the queries, for example: WHERE LOWER(login) = LOWER('12345')' How can i force otrs to use WHERE login = 12345 ? Thanks
5708
Age (days ago)
5708
Last active (days ago)
0 comments
1 participants
participants (1)
-
Tommaso Calosi - Brain Technology