3 ms·
That sounds like newbie developers wrote that and no DBAs were involved in checking the code, not a database design problem, you are throwing blame without kno
by AdrianB1 5y ago
That sounds like newbie developers wrote that and no DBAs were involved in checking the code, not a database design problem, you are throwing blame without knowing enough about the matter. If your string fit in a varchar, it makes absolutely no sense to change it to nvarchar because your query has unicode as input.
- xupybd 5y agoWhat? The database made the call to compare the strings as Unicode. Are you accusing the DB developers of not doing their job?
- AdrianB1 5y agoYes, databases don't decide, developers do.
- eyelidlessness 5y agoI reread the parent quote several times and cannot detect a hint of throwing blame at all.
- superjan 5y agoMost, but not all of the team were young, and the DB schema was designed by themselves. I did not intend to throw blame. It is more the kind of situation where a sensible decision (at first glance) creates a footgun down the road.