4 ms·
I understand it might not be possible due to other contraints, but in smaller projects with international addresses I just used a text/memo field for the addres
by the-dude 5y ago
I understand it might not be possible due to other contraints, but in smaller projects with international addresses I just used a text/memo field for the address and seperate field for the country.
Addresses now can be entered the way the user prefers.
- thatwasunusual 5y agoThis works fine for _small_ systems. But with large data sets, where you actually want to act upon the data, it's impossible to have it stored as text. One lazy solution would of course be to index that data into Elasticsearch (or similar solutions), but you will end up with database records that have missing or invalid indexed data at some point. A NoSQL solution is far from perfect, but for us it was _a lot_ better than just storing it as text somewhere.